﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_Task_AddComment]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_Task_AddComment];
GO
CREATE PROCEDURE [dbo].[sproc_Task_AddComment]
    @Username nvarchar(300),
    @TaskID int, 
    @Comment ntext
AS
INSERT INTO uds_task_comment (TaskID,Username,Comment)
    VALUES(@TaskID,@Username,@Comment)